package com.shtel.custbehavior.mapper;

import com.shtel.custbehavior.entity.*;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
@Mapper
public interface QueryMapper {

    //查询投诉信息
    @Select("select * from tousuinfo where creditnum=#{creditnum}")
    public List<TousuInfo> querytousuinfo(@Param("creditnum") String creditnum);

    //查询感知信息
    @Select("select * from feelinfo where creditnum=#{creditnum}")
    public List<FeelInfo> queryfeelinfo(@Param("creditnum") String creditnum);

    //查询接触轨迹
    @Select("select * from contactinfo where creditnum=#{creditnum}")
    public List<ContactInfo> querycontactinfo(@Param("creditnum") String creditnum);

    //查询服务信息
    @Select("select * from serviceinfo where creditnum=#{creditnum}")
    public List<ServiceInfo> queryserviceinfo(@Param("creditnum") String creditnum);

    //查询营销标签
    @Select("select * from custlabel where creditnum=#{creditnum}")
    public List<CustLabel> querycustlabel(@Param("creditnum") String creditnum);

    //营业员登录
    @Select("select id from account where username=#{username} and password=#{password}")
    public Integer login(@Param("username") String username,@Param("password") String password);

}
